CREATE TABLE [dbo].[Customers]
(
[Id] [int] NOT NULL,
[LastName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[FirstName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[Surname] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[Email] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[PhoneNumber] [varchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[CreateStamp] [date] NULL CONSTRAINT [DF_Customers_CreateStamp] DEFAULT (getdate()),
[MembershipId] [uniqueidentifier] NOT NULL
)
ALTER TABLE [dbo].[Customers] ADD
CONSTRAINT [FK_Customers_aspnet_Users] FOREIGN KEY ([MembershipId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
GO
